package com.zsgeek.dao;

import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;

import com.mysql.jdbc.StringUtils;
import com.zsgeek.db.DBUtils;
import com.zsgeek.db.ResultSetHandler;
import com.zsgeek.entity.Task_info;
import com.zsgeek.util.PageHelper;

public class Task_infoDao {
	

	/**
	 * 新增订单任务
	 * 
	 * @param operation_conf
	 * @return
	 */
	public static boolean add(Task_info task_info) {
		String sql = "INSERT INTO task_info (email,orderNo,asin,sale_id,pro_price,p_price,pro_key,"
				+ "pro_url,pro_title,pro_name,order_url_one_day,order_url_two_day,"
				+ "order_url_three_day,order_url_four_day,order_url_five_day,"
				+ "order_url_six_day,order_url_seven_day,order_url_eight_day,"
				+ "order_url_nine_day,order_url_ten_day,order_url_charge,"
				+ "order_ad_one_day,order_ad_two_day,order_ad_three_day,"
				+ "order_ad_four_day,order_ad_five_day,order_ad_six_day,"
				+ "order_ad_seven_day,order_ad_eight_day,order_ad_nine_day,"
				+ "order_ad_ten_day,order_ad_charge,order_result_one_day,"
				+ "order_result_two_day,order_result_three_day,order_result_four_day,"
				+ "order_result_five_day,order_result_six_day,order_result_seven_day,"
				+ "order_result_eight_day,order_result_nine_day,order_result_ten_day,"
				+ "order_result_charge,review_one_day,review_one_day_info,"
				+ "review_two_day,review_two_day_info,review_three_day,"
				+ "review_three_day_info,review_four_day,review_four_day_info,"
				+ "review_five_day,review_five_day_info,review_six_day,"
				+ "review_six_day_info,review_seven_day,review_seven_day_info,"
				+ "review_eight_day,review_eight_day_info,review_nine_day,"
				+ "review_nine_day_info,review_ten_day,review_ten_day_info,"
				+ "review_charge,feedback_one_day,feedback_one_day_info,"
				+ "feedback_two_day,feedback_two_day_info,feedback_three_day,"
				+ "feedback_three_day_info,feedback_four_day,feedback_four_day_info,"
				+ "feedback_five_day,feedback_five_day_info,feedback_six_day,"
				+ "feedback_six_day_info,feedback_seven_day,feedback_seven_day_info,"
				+ "feedback_eight_day,feedback_eight_day_info,feedback_nine_day,"
				+ "feedback_nine_day_info,feedback_ten_day,feedback_ten_day_info,"
				+ "feedback_charge,flow_url_one_day,flow_url_two_day,"
				+ "flow_url_three_day,flow_url_four_day,flow_url_five_day,"
				+ "flow_url_six_day,flow_url_seven_day,flow_url_eight_day,"
				+ "flow_url_nine_day,flow_url_ten_day,flow_url_charge,"
				+ "flow_result_one_day,flow_result_two_day,flow_result_three_day,"
				+ "flow_result_four_day,flow_result_five_day,flow_result_six_day,"
				+ "flow_result_seven_day,flow_result_eight_day,flow_result_nine_day,"
				+ "flow_result_ten_day,flow_result_charge,"
				+ "flow_ad_one_day,flow_ad_two_day,"
				+ "flow_ad_three_day,flow_ad_four_day,flow_ad_five_day,flow_ad_six_day,"
				+ "flow_ad_seven_day,flow_ad_eight_day,flow_ad_nine_day,flow_ad_ten_day,"
				+ "flow_ad_charge,wish_url_one_day,"
				+ "wish_url_two_day,wish_url_three_day,wish_url_four_day,"
				+ "wish_url_five_day,wish_url_six_day,wish_url_seven_day,"
				+ "wish_url_eight_day,wish_url_nine_day,wish_url_ten_day,"
				+ "wish_url_charge,wish_result_one_day,wish_result_two_day,"
				+ "wish_result_three_day,wish_result_four_day,wish_result_five_day,"
				+ "wish_result_six_day,wish_result_seven_day,wish_result_eight_day,"
				+ "wish_result_nine_day,wish_result_ten_day,wish_result_charge,"
				+ "cart_url_one_day,cart_url_two_day,cart_url_three_day,"
				+ "cart_url_four_day,cart_url_five_day,cart_url_six_day,"
				+ "cart_url_seven_day,cart_url_eight_day,cart_url_nine_day,"
				+ "cart_url_ten_day,cart_url_charge,cart_result_one_day,"
				+ "cart_result_two_day,cart_result_three_day,cart_result_four_day,"
				+ "cart_result_five_day,cart_result_six_day,cart_result_seven_day,"
				+ "cart_result_eight_day,cart_result_nine_day,cart_result_ten_day,"
				+ "cart_result_charge,createtime,one_day,two_day,three_day,"
				+ "four_day,five_day,six_day,seven_day,eight_day,nine_day,ten_day,"
				+ "flow_checked,flow_rate,hope_checked,hope_rate,favorite_checked,"
				+ "favorite_rate,pay_remark,procedureNum,payNum,order_check,order_type,"
				+ "question,ping_title,yasin,ysale_id,ypro_price,yp_price,ypro_key,ypro_url,"
				+ "ypro_title,ypro_name,siteId"
				+ ") VALUES("
				+ "?,?,?,?,?,?,?,?,?,"
				+ "?,?,?,?,?,?,?,?,?,?,"
				+ "?,?,?,?,?,?,?,?,?,?,"
				+ "?,?,?,?,?,?,?,?,?,?,"
				+ "?,?,?,?,?,?,?,?,?,?,"
				+ "?,?,?,?,?,?,?,?,?,?,"
				+ "?,?,?,?,?,?,?,?,?,?,"
				+ "?,?,?,?,?,?,?,?,?,?,"
				+ "?,?,?,?,?,?,?,?,?,?,"
				+ "?,?,?,?,?,?,?,?,?,?,"
				+ "?,?,?,?,?,?,?,?,?,?,"
				+ "?,?,?,?,?,?,?,?,?,?,"
				+ "?,?,?,?,?,?,?,?,?,?,"
				+ "?,?,?,?,?,?,?,?,?,?,"
				+ "?,?,?,?,?,?,?,?,?,?,"
				+ "?,?,?,?,?,?,?,?,?,?," 
				+ "?,?,?,?,?,?,?,?,?,?,"
				+ "?,?,?,?,?,?,?,?,?,?,"
				+ "?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) ";
		return DBUtils.executeUpdate(sql, task_info.getEmail(),
				task_info.getOrderNo(), task_info.getAsin(),
				task_info.getSale_id(), task_info.getPro_price(),
				task_info.getP_price(), task_info.getPro_key(),
				task_info.getPro_url(), task_info.getPro_title(),
				task_info.getPro_name(), task_info.getOrder_url_one_day(),
				task_info.getOrder_url_two_day(),
				task_info.getOrder_url_three_day(),
				task_info.getOrder_url_four_day(),
				task_info.getOrder_url_five_day(),
				task_info.getOrder_url_six_day(),
				task_info.getOrder_url_seven_day(),
				task_info.getOrder_url_eight_day(),
				task_info.getOrder_url_nine_day(),
				task_info.getOrder_url_ten_day(),
				task_info.getOrder_url_charge(),
				task_info.getOrder_ad_one_day(),
				task_info.getOrder_ad_two_day(),
				task_info.getOrder_ad_three_day(),
				task_info.getOrder_ad_four_day(),
				task_info.getOrder_ad_five_day(),
				task_info.getOrder_ad_six_day(),
				task_info.getOrder_ad_seven_day(),
				task_info.getOrder_ad_eight_day(),
				task_info.getOrder_ad_nine_day(),
				task_info.getOrder_ad_ten_day(),
				task_info.getOrder_ad_charge(),
				task_info.getOrder_result_one_day(),
				task_info.getOrder_result_two_day(),
				task_info.getOrder_result_three_day(),
				task_info.getOrder_result_four_day(),
				task_info.getOrder_result_five_day(),
				task_info.getOrder_result_six_day(),
				task_info.getOrder_result_seven_day(),
				task_info.getOrder_result_eight_day(),
				task_info.getOrder_result_nine_day(),
				task_info.getOrder_result_ten_day(),
				task_info.getOrder_result_charge(),
				task_info.getReview_one_day(),
				task_info.getReview_one_day_info(),
				task_info.getReview_two_day(),
				task_info.getReview_two_day_info(),
				task_info.getReview_three_day(),
				task_info.getReview_three_day_info(),
				task_info.getReview_four_day(),
				task_info.getReview_four_day_info(),
				task_info.getReview_five_day(),
				task_info.getReview_five_day_info(),
				task_info.getReview_six_day(),
				task_info.getReview_six_day_info(),
				task_info.getReview_seven_day(),
				task_info.getReview_seven_day_info(),
				task_info.getReview_eight_day(),
				task_info.getReview_eight_day_info(),
				task_info.getReview_nine_day(),
				task_info.getReview_nine_day_info(),
				task_info.getReview_ten_day(),
				task_info.getReview_ten_day_info(),
				task_info.getReview_charge(), 
				task_info.getFeedback_one_day(),
				task_info.getFeedback_one_day_info(),
				task_info.getFeedback_two_day(),
				task_info.getFeedback_two_day_info(),
				task_info.getFeedback_three_day(),
				task_info.getFeedback_three_day_info(),
				task_info.getFeedback_four_day(),
				task_info.getFeedback_four_day_info(),
				task_info.getFeedback_five_day(),
				task_info.getFeedback_five_day_info(),
				task_info.getFeedback_six_day(),
				task_info.getFeedback_six_day_info(),
				task_info.getFeedback_seven_day(),
				task_info.getFeedback_seven_day_info(),
				task_info.getFeedback_eight_day(),
				task_info.getFeedback_eight_day_info(),
				task_info.getFeedback_nine_day(),
				task_info.getFeedback_nine_day_info(),
				task_info.getFeedback_ten_day(),
				task_info.getFeedback_ten_day_info(),
				task_info.getFeedback_charge(),
				task_info.getFlow_url_one_day(),
				task_info.getFlow_url_two_day(),
				task_info.getFlow_url_three_day(),
				task_info.getFlow_url_four_day(),
				task_info.getFlow_url_five_day(),
				task_info.getFlow_url_six_day(),
				task_info.getFlow_url_seven_day(),
				task_info.getFlow_url_eight_day(),
				task_info.getFlow_url_nine_day(),
				task_info.getFlow_url_ten_day(),
				task_info.getFlow_url_charge(),
				task_info.getFlow_result_one_day(),
				task_info.getFlow_result_two_day(),
				task_info.getFlow_result_three_day(),
				task_info.getFlow_result_four_day(),
				task_info.getFlow_result_five_day(),
				task_info.getFlow_result_six_day(),
				task_info.getFlow_result_seven_day(),
				task_info.getFlow_result_eight_day(),
				task_info.getFlow_result_nine_day(),
				task_info.getFlow_result_ten_day(),
				task_info.getFlow_result_charge(),
				task_info.getFlow_ad_one_day(),
				task_info.getFlow_ad_two_day(),
				task_info.getFlow_ad_three_day(),
				task_info.getFlow_ad_four_day(),
				task_info.getFlow_ad_five_day(),
				task_info.getFlow_ad_six_day(),
				task_info.getFlow_ad_seven_day(),
				task_info.getFlow_ad_eight_day(),
				task_info.getFlow_ad_nine_day(),
				task_info.getFlow_ad_ten_day(),
				task_info.getFlow_ad_charge(),
				task_info.getWish_url_one_day(),
				task_info.getWish_url_two_day(),
				task_info.getWish_url_three_day(),
				task_info.getWish_url_four_day(),
				task_info.getWish_url_five_day(),
				task_info.getWish_url_six_day(),
				task_info.getWish_url_seven_day(),
				task_info.getWish_url_eight_day(),
				task_info.getWish_url_nine_day(),
				task_info.getWish_url_ten_day(),
				task_info.getWish_url_charge(),
				task_info.getWish_result_one_day(),
				task_info.getWish_result_two_day(),
				task_info.getWish_result_three_day(),
				task_info.getWish_result_four_day(),
				task_info.getWish_result_five_day(),
				task_info.getWish_result_six_day(),
				task_info.getWish_result_seven_day(),
				task_info.getWish_result_eight_day(),
				task_info.getWish_result_nine_day(),
				task_info.getWish_result_ten_day(),
				task_info.getWish_result_charge(),
				task_info.getCart_url_one_day(),
				task_info.getCart_url_two_day(),
				task_info.getCart_url_three_day(),
				task_info.getCart_url_four_day(),
				task_info.getCart_url_five_day(),
				task_info.getCart_url_six_day(),
				task_info.getCart_url_seven_day(),
				task_info.getCart_url_eight_day(),
				task_info.getCart_url_nine_day(),
				task_info.getCart_url_ten_day(),
				task_info.getCart_url_charge(),
				task_info.getCart_result_one_day(),
				task_info.getCart_result_two_day(),
				task_info.getCart_result_three_day(),
				task_info.getCart_result_four_day(),
				task_info.getCart_result_five_day(),
				task_info.getCart_result_six_day(),
				task_info.getCart_result_seven_day(),
				task_info.getCart_result_eight_day(),
				task_info.getCart_result_nine_day(),
				task_info.getCart_result_ten_day(),
				task_info.getCart_result_charge(), 
				task_info.getCreatetime(),
				task_info.getOne_day(),
				task_info.getTwo_day(),
				task_info.getThree_day(),
				task_info.getFour_day(),
				task_info.getFive_day(),
				task_info.getSix_day(),
				task_info.getSeven_day(),
				task_info.getEight_day(),
				task_info.getNine_day(),
				task_info.getTen_day(),
				task_info.getFlow_checked(),
				task_info.getFlow_rate(),
				task_info.getHope_checked(),
				task_info.getHope_rate(),
				task_info.getFavorite_checked(),
				task_info.getFavorite_rate(),
				task_info.getPay_remark(),
				task_info.getProcedureNum(),
				task_info.getPayNum(),
				task_info.getOrder_check(),
				task_info.getOrder_type(),
				task_info.getQuestion(),
				task_info.getPing_title(),
				task_info.getYasin(),
				task_info.getYsale_id(), task_info.getYpro_price(),
				task_info.getYp_price(), task_info.getYpro_key(),
				task_info.getYpro_url(), task_info.getYpro_title(),
				task_info.getYpro_name(),task_info.getSiteId()) > 0;
	}

	/**
	 * 根据订单编号查询订单任务详情
	 * 
	 * @param orderNo
	 * @return
	 */
	public static Task_info getByOrderNo(String orderNo) {
		String sql = "SELECT asin,sale_id,pro_price,p_price,pro_key,"
				+ "pro_url,pro_title,pro_name,order_url_one_day,order_url_two_day,"
				+ "order_url_three_day,order_url_four_day,order_url_five_day,"
				+ "order_url_six_day,order_url_seven_day,order_url_eight_day,"
				+ "order_url_nine_day,order_url_ten_day,order_url_charge,"
				+ "order_ad_one_day,order_ad_two_day,order_ad_three_day,"
				+ "order_ad_four_day,order_ad_five_day,order_ad_six_day,"
				+ "order_ad_seven_day,order_ad_eight_day,order_ad_nine_day,"
				+ "order_ad_ten_day,order_ad_charge,order_result_one_day,"
				+ "order_result_two_day,order_result_three_day,order_result_four_day,"
				+ "order_result_five_day,order_result_six_day,order_result_seven_day,"
				+ "order_result_eight_day,order_result_nine_day,order_result_ten_day,"
				+ "order_result_charge,review_one_day,review_one_day_info,"
				+ "review_two_day,review_two_day_info,review_three_day,"
				+ "review_three_day_info,review_four_day,review_four_day_info,"
				+ "review_five_day,review_five_day_info,review_six_day,"
				+ "review_six_day_info,review_seven_day,review_seven_day_info,"
				+ "review_eight_day,review_eight_day_info,review_nine_day,"
				+ "review_nine_day_info,review_ten_day,review_ten_day_info,"
				+ "review_charge,feedback_one_day,feedback_one_day_info,"
				+ "feedback_two_day,feedback_two_day_info,feedback_three_day,"
				+ "feedback_three_day_info,feedback_four_day,feedback_four_day_info,"
				+ "feedback_five_day,feedback_five_day_info,feedback_six_day,"
				+ "feedback_six_day_info,feedback_seven_day,feedback_seven_day_info,"
				+ "feedback_eight_day,feedback_eight_day_info,feedback_nine_day,"
				+ "feedback_nine_day_info,feedback_ten_day,feedback_ten_day_info,"
				+ "feedback_charge,flow_url_one_day,flow_url_two_day,"
				+ "flow_url_three_day,flow_url_four_day,flow_url_five_day,"
				+ "flow_url_six_day,flow_url_seven_day,flow_url_eight_day,"
				+ "flow_url_nine_day,flow_url_ten_day,flow_url_charge,"
				+ "flow_result_one_day,flow_result_two_day,flow_result_three_day,"
				+ "flow_result_four_day,flow_result_five_day,flow_result_six_day,"
				+ "flow_result_seven_day,flow_result_eight_day,flow_result_nine_day,"
				+ "flow_result_ten_day,flow_result_charge,flow_ad_one_day,flow_ad_two_day,"
				+ "flow_ad_three_day,flow_ad_four_day,flow_ad_five_day,flow_ad_six_day,"
				+ "flow_ad_seven_day,flow_ad_eight_day,flow_ad_nine_day,flow_ad_ten_day,"
				+ "flow_ad_charge,wish_url_one_day,"
				+ "wish_url_two_day,wish_url_three_day,wish_url_four_day,"
				+ "wish_url_five_day,wish_url_six_day,wish_url_seven_day,"
				+ "wish_url_eight_day,wish_url_nine_day,wish_url_ten_day,"
				+ "wish_url_charge,wish_result_one_day,wish_result_two_day,"
				+ "wish_result_three_day,wish_result_four_day,wish_result_five_day,"
				+ "wish_result_six_day,wish_result_seven_day,wish_result_eight_day,"
				+ "wish_result_nine_day,wish_result_ten_day,wish_result_charge,"
				+ "cart_url_one_day,cart_url_two_day,cart_url_three_day,"
				+ "cart_url_four_day,cart_url_five_day,cart_url_six_day,"
				+ "cart_url_seven_day,cart_url_eight_day,cart_url_nine_day,"
				+ "cart_url_ten_day,cart_url_charge,cart_result_one_day,"
				+ "cart_result_two_day,cart_result_three_day,cart_result_four_day,"
				+ "cart_result_five_day,cart_result_six_day,cart_result_seven_day,"
				+ "cart_result_eight_day,cart_result_nine_day,cart_result_ten_day,"
				+ "cart_result_charge,orderNo,orderState,createtime,"
				+ "one_day,two_day,three_day,four_day,five_day,six_day,seven_day,eight_day,"
				+ "nine_day,ten_day,id,flow_checked,flow_rate,hope_checked,hope_rate,"
				+ "favorite_checked,favorite_rate,pay_remark,procedureNum,payNum,"
				+ "order_check,order_type,question,ping_title,"
				+ "yasin,ysale_id,ypro_price,yp_price,ypro_key,ypro_url,ypro_title,ypro_name,siteId "
				+ "FROM task_info WHERE orderNo = ?";
		return (Task_info) DBUtils.executeQuery(sql, new ResultSetHandler() {
			@Override
			public Object doHandler(ResultSet rs) throws SQLException {
				Task_info task_info  = null;
				if (rs.next()) {
					task_info = new Task_info();
					task_info.setAsin(rs.getString(1));
					task_info.setSale_id(rs.getString(2));
					task_info.setPro_price(rs.getDouble(3));
					task_info.setP_price(rs.getDouble(4));
					task_info.setPro_key(rs.getString(5));
					task_info.setPro_url(rs.getString(6));
					task_info.setPro_title(rs.getString(7));
					task_info.setPro_name(rs.getString(8));
					task_info.setOrder_url_one_day(rs.getInt(9));
					task_info.setOrder_url_two_day(rs.getInt(10));
					task_info.setOrder_url_three_day(rs.getInt(11));
					task_info.setOrder_url_four_day(rs.getInt(12));
					task_info.setOrder_url_five_day(rs.getInt(13));
					task_info.setOrder_url_six_day(rs.getInt(14));
					task_info.setOrder_url_seven_day(rs.getInt(15));
					task_info.setOrder_url_eight_day(rs.getInt(16));
					task_info.setOrder_url_nine_day(rs.getInt(17));
					task_info.setOrder_url_ten_day(rs.getInt(18));
					task_info.setOrder_url_charge(rs.getDouble(19));
					task_info.setOrder_ad_one_day(rs.getInt(20));
					task_info.setOrder_ad_two_day(rs.getInt(21));
					task_info.setOrder_ad_three_day(rs.getInt(22));
					task_info.setOrder_ad_four_day(rs.getInt(23));
					task_info.setOrder_ad_five_day(rs.getInt(24));
					task_info.setOrder_ad_six_day(rs.getInt(25));
					task_info.setOrder_ad_seven_day(rs.getInt(26));
					task_info.setOrder_ad_eight_day(rs.getInt(27));
					task_info.setOrder_ad_nine_day(rs.getInt(28));
					task_info.setOrder_ad_ten_day(rs.getInt(29));
					task_info.setOrder_ad_charge(rs.getDouble(30));
					task_info.setOrder_result_one_day(rs.getInt(31));
					task_info.setOrder_result_two_day(rs.getInt(32));
					task_info.setOrder_result_three_day(rs.getInt(33));
					task_info.setOrder_result_four_day(rs.getInt(34));
					task_info.setOrder_result_five_day(rs.getInt(35));
					task_info.setOrder_result_six_day(rs.getInt(36));
					task_info.setOrder_result_seven_day(rs.getInt(37));
					task_info.setOrder_result_eight_day(rs.getInt(38));
					task_info.setOrder_result_nine_day(rs.getInt(39));
					task_info.setOrder_result_ten_day(rs.getInt(40));
					task_info.setOrder_result_charge(rs.getDouble(41));
					task_info.setReview_one_day(rs.getInt(42));
					task_info.setReview_one_day_info(rs.getString(43));
					task_info.setReview_two_day(rs.getInt(44));
					task_info.setReview_two_day_info(rs.getString(45));
					task_info.setReview_three_day(rs.getInt(46));
					task_info.setReview_three_day_info(rs.getString(47));
					task_info.setReview_four_day(rs.getInt(48));
					task_info.setReview_four_day_info(rs.getString(49));
					task_info.setReview_five_day(rs.getInt(50));
					task_info.setReview_five_day_info(rs.getString(51));
					task_info.setReview_six_day(rs.getInt(52));
					task_info.setReview_six_day_info(rs.getString(53));
					task_info.setReview_seven_day(rs.getInt(54));
					task_info.setReview_seven_day_info(rs.getString(55));
					task_info.setReview_eight_day(rs.getInt(56));
					task_info.setReview_eight_day_info(rs.getString(57));
					task_info.setReview_nine_day(rs.getInt(58));
					task_info.setReview_nine_day_info(rs.getString(59));
					task_info.setReview_ten_day(rs.getInt(60));
					task_info.setReview_ten_day_info(rs.getString(61));
					task_info.setReview_charge(rs.getDouble(62));
					task_info.setFeedback_one_day(rs.getInt(63));
					task_info.setFeedback_one_day_info(rs.getString(64));
					task_info.setFeedback_two_day(rs.getInt(65));
					task_info.setFeedback_two_day_info(rs.getString(66));
					task_info.setFeedback_three_day(rs.getInt(67));
					task_info.setFeedback_three_day_info(rs.getString(68));
					task_info.setFeedback_four_day(rs.getInt(69));
					task_info.setFeedback_four_day_info(rs.getString(70));
					task_info.setFeedback_five_day(rs.getInt(71));
					task_info.setFeedback_five_day_info(rs.getString(72));
					task_info.setFeedback_six_day(rs.getInt(73));
					task_info.setFeedback_six_day_info(rs.getString(74));
					task_info.setFeedback_seven_day(rs.getInt(75));
					task_info.setFeedback_seven_day_info(rs.getString(76));
					task_info.setFeedback_eight_day(rs.getInt(77));
					task_info.setFeedback_eight_day_info(rs.getString(78));
					task_info.setFeedback_nine_day(rs.getInt(79));
					task_info.setFeedback_nine_day_info(rs.getString(80));
					task_info.setFeedback_ten_day(rs.getInt(81));
					task_info.setFeedback_ten_day_info(rs.getString(82));
					task_info.setFeedback_charge(rs.getDouble(83));
					task_info.setFlow_url_one_day(rs.getInt(84));
					task_info.setFlow_url_two_day(rs.getInt(85));
					task_info.setFlow_url_three_day(rs.getInt(86));
					task_info.setFlow_url_four_day(rs.getInt(87));
					task_info.setFlow_url_five_day(rs.getInt(88));
					task_info.setFlow_url_six_day(rs.getInt(89));
					task_info.setFlow_url_seven_day(rs.getInt(90));
					task_info.setFlow_url_eight_day(rs.getInt(91));
					task_info.setFlow_url_nine_day(rs.getInt(92));
					task_info.setFlow_url_ten_day(rs.getInt(93));
					task_info.setFlow_url_charge(rs.getDouble(94));
					task_info.setFlow_result_one_day(rs.getInt(95));
					task_info.setFlow_result_two_day(rs.getInt(96));
					task_info.setFlow_result_three_day(rs.getInt(97));
					task_info.setFlow_result_four_day(rs.getInt(98));
					task_info.setFlow_result_five_day(rs.getInt(99));
					task_info.setFlow_result_six_day(rs.getInt(100));
					task_info.setFlow_result_seven_day(rs.getInt(101));
					task_info.setFlow_result_eight_day(rs.getInt(102));
					task_info.setFlow_result_nine_day(rs.getInt(103));
					task_info.setFlow_result_ten_day(rs.getInt(104));
					task_info.setFlow_result_charge(rs.getDouble(105));
					task_info.setFlow_ad_one_day(rs.getInt(106));
					task_info.setFlow_ad_two_day(rs.getInt(107));
					task_info.setFlow_ad_three_day(rs.getInt(108));
					task_info.setFlow_ad_four_day(rs.getInt(109));
					task_info.setFlow_ad_five_day(rs.getInt(110));
					task_info.setFlow_ad_six_day(rs.getInt(111));
					task_info.setFlow_ad_seven_day(rs.getInt(112));
					task_info.setFlow_ad_eight_day(rs.getInt(113));
					task_info.setFlow_ad_nine_day(rs.getInt(114));
					task_info.setFlow_ad_ten_day(rs.getInt(115));
					task_info.setFlow_ad_charge(rs.getDouble(116));
					task_info.setWish_url_one_day(rs.getInt(117));
					task_info.setWish_url_two_day(rs.getInt(118));
					task_info.setWish_url_three_day(rs.getInt(119));
					task_info.setWish_url_four_day(rs.getInt(120));
					task_info.setWish_url_five_day(rs.getInt(121));
					task_info.setWish_url_six_day(rs.getInt(122));
					task_info.setWish_url_seven_day(rs.getInt(123));
					task_info.setWish_url_eight_day(rs.getInt(124));
					task_info.setWish_url_nine_day(rs.getInt(125));
					task_info.setWish_url_ten_day(rs.getInt(126));
					task_info.setWish_url_charge(rs.getDouble(127));
					task_info.setWish_result_one_day(rs.getInt(128));
					task_info.setWish_result_two_day(rs.getInt(129));
					task_info.setWish_result_three_day(rs.getInt(130));
					task_info.setWish_result_four_day(rs.getInt(131));
					task_info.setWish_result_five_day(rs.getInt(132));
					task_info.setWish_result_six_day(rs.getInt(133));
					task_info.setWish_result_seven_day(rs.getInt(134));
					task_info.setWish_result_eight_day(rs.getInt(135));
					task_info.setWish_result_nine_day(rs.getInt(136));
					task_info.setWish_result_ten_day(rs.getInt(137));
					task_info.setWish_result_charge(rs.getDouble(138));
					task_info.setCart_url_one_day(rs.getInt(139));
					task_info.setCart_url_two_day(rs.getInt(140));
					task_info.setCart_url_three_day(rs.getInt(141));
					task_info.setCart_url_four_day(rs.getInt(142));
					task_info.setCart_url_five_day(rs.getInt(143));
					task_info.setCart_url_six_day(rs.getInt(144));
					task_info.setCart_url_seven_day(rs.getInt(145));
					task_info.setCart_url_eight_day(rs.getInt(146));
					task_info.setCart_url_nine_day(rs.getInt(147));
					task_info.setCart_url_ten_day(rs.getInt(148));
					task_info.setCart_url_charge(rs.getDouble(149));
					task_info.setCart_result_one_day(rs.getInt(150));
					task_info.setCart_result_two_day(rs.getInt(151));
					task_info.setCart_result_three_day(rs.getInt(152));
					task_info.setCart_result_four_day(rs.getInt(153));
					task_info.setCart_result_five_day(rs.getInt(154));
					task_info.setCart_result_six_day(rs.getInt(155));
					task_info.setCart_result_seven_day(rs.getInt(156));
					task_info.setCart_result_eight_day(rs.getInt(157));
					task_info.setCart_result_nine_day(rs.getInt(158));
					task_info.setCart_result_ten_day(rs.getInt(159));
					task_info.setCart_result_charge(rs.getDouble(160));
					task_info.setOrderNo(rs.getString(161));
					task_info.setOrderState(rs.getInt(162));
					task_info.setCreatetime(rs.getLong(163));
					task_info.setOne_day(rs.getString(164));
					task_info.setTwo_day(rs.getString(165));
					task_info.setThree_day(rs.getString(166));
					task_info.setFour_day(rs.getString(167));
					task_info.setFive_day(rs.getString(168));
					task_info.setSix_day(rs.getString(169));
					task_info.setSeven_day(rs.getString(170));
					task_info.setEight_day(rs.getString(171));
					task_info.setNine_day(rs.getString(172));
					task_info.setTen_day(rs.getString(173));
					task_info.setId(rs.getInt(174));
					task_info.setFlow_checked(rs.getInt(175));
					task_info.setFlow_rate(rs.getDouble(176));
					task_info.setHope_checked(rs.getInt(177));
					task_info.setHope_rate(rs.getDouble(178));
					task_info.setFavorite_checked(rs.getInt(179));
					task_info.setFavorite_rate(rs.getDouble(180));
					task_info.setPay_remark(rs.getString(181));
					task_info.setProcedureNum(rs.getDouble(182));
					task_info.setPayNum(rs.getDouble(183));
					task_info.setOrder_check(rs.getInt(184));
					task_info.setOrder_type(rs.getInt(185));
					task_info.setQuestion(rs.getString(186));
					task_info.setPing_title(rs.getString(187));
					task_info.setYasin(rs.getString(188));
					task_info.setYsale_id(rs.getString(189));
					task_info.setYpro_price(rs.getDouble(190));
					task_info.setYp_price(rs.getDouble(191));
					task_info.setYpro_key(rs.getString(192));
					task_info.setYpro_url(rs.getString(193));
					task_info.setYpro_title(rs.getString(194));
					task_info.setYpro_name(rs.getString(195));
					task_info.setSiteId(rs.getInt(196));
				}
				rs.close();
				return task_info;
			}
		}, orderNo);
	}

	/**
	 * 根据用户email（登录帐号）分页查询全部订单任务(前台)
	 * 
	 * @param email
	 *            pageHelper
	 * @return
	 */
	@SuppressWarnings("unchecked")
	public static List<Task_info> getUserList(String email, String orderState,String order_type,
			PageHelper pageHelper) {
		StringBuilder str = new StringBuilder();
		str.append("SELECT COUNT(id) FROM task_info WHERE   ");
		if (!StringUtils.isNullOrEmpty(email)) {
			str.append(" email=? ");
		}else{
			str.append(" 1=? ");
		}
		
		if (!StringUtils.isNullOrEmpty(orderState)) {
			
			if (Integer.parseInt(orderState)!=0) {
				str.append(" AND orderState > 0  AND 1=?");
			}else {
				str.append(" AND orderState=? ");
			}
			
		} else {
			str.append(" AND 1=? ");
		}
		
		if (!StringUtils.isNullOrEmpty(order_type)) {
			str.append(" AND order_type=? ");
		}else{
			str.append(" AND 1=? ");
		}
		Integer count = Integer.parseInt(DBUtils.executeQuery(str.toString(),
				StringUtils.isNullOrEmpty(email)?1:email, 
						StringUtils.isNullOrEmpty(orderState) ? 1 : orderState,
								StringUtils.isNullOrEmpty(order_type)?1:order_type)
				.toString());
		pageHelper.setTotalCount(count); // 设置总记录数

		String sql = "SELECT  asin,sale_id,pro_price,p_price,pro_key,"
				+ "pro_url,pro_title,pro_name,order_url_one_day,order_url_two_day,"
				+ "order_url_three_day,order_url_four_day,order_url_five_day,"
				+ "order_url_six_day,order_url_seven_day,order_url_eight_day,"
				+ "order_url_nine_day,order_url_ten_day,order_url_charge,"
				+ "order_ad_one_day,order_ad_two_day,order_ad_three_day,"
				+ "order_ad_four_day,order_ad_five_day,order_ad_six_day,"
				+ "order_ad_seven_day,order_ad_eight_day,order_ad_nine_day,"
				+ "order_ad_ten_day,order_ad_charge,order_result_one_day,"
				+ "order_result_two_day,order_result_three_day,order_result_four_day,"
				+ "order_result_five_day,order_result_six_day,order_result_seven_day,"
				+ "order_result_eight_day,order_result_nine_day,order_result_ten_day,"
				+ "order_result_charge,review_one_day,review_one_day_info,"
				+ "review_two_day,review_two_day_info,review_three_day,"
				+ "review_three_day_info,review_four_day,review_four_day_info,"
				+ "review_five_day,review_five_day_info,review_six_day,"
				+ "review_six_day_info,review_seven_day,review_seven_day_info,"
				+ "review_eight_day,review_eight_day_info,review_nine_day,"
				+ "review_nine_day_info,review_ten_day,review_ten_day_info,"
				+ "review_charge,feedback_one_day,feedback_one_day_info,"
				+ "feedback_two_day,feedback_two_day_info,feedback_three_day,"
				+ "feedback_three_day_info,feedback_four_day,feedback_four_day_info,"
				+ "feedback_five_day,feedback_five_day_info,feedback_six_day,"
				+ "feedback_six_day_info,feedback_seven_day,feedback_seven_day_info,"
				+ "feedback_eight_day,feedback_eight_day_info,feedback_nine_day,"
				+ "feedback_nine_day_info,feedback_ten_day,feedback_ten_day_info,"
				+ "feedback_charge,flow_url_one_day,flow_url_two_day,"
				+ "flow_url_three_day,flow_url_four_day,flow_url_five_day,"
				+ "flow_url_six_day,flow_url_seven_day,flow_url_eight_day,"
				+ "flow_url_nine_day,flow_url_ten_day,flow_url_charge,"
				+ "flow_result_one_day,flow_result_two_day,flow_result_three_day,"
				+ "flow_result_four_day,flow_result_five_day,flow_result_six_day,"
				+ "flow_result_seven_day,flow_result_eight_day,flow_result_nine_day,"
				+ "flow_result_ten_day,flow_result_charge,flow_ad_one_day,flow_ad_two_day,"
				+ "flow_ad_three_day,flow_ad_four_day,flow_ad_five_day,flow_ad_six_day,"
				+ "flow_ad_seven_day,flow_ad_eight_day,flow_ad_nine_day,flow_ad_ten_day,"
				+ "flow_ad_charge,wish_url_one_day,"
				+ "wish_url_two_day,wish_url_three_day,wish_url_four_day,"
				+ "wish_url_five_day,wish_url_six_day,wish_url_seven_day,"
				+ "wish_url_eight_day,wish_url_nine_day,wish_url_ten_day,"
				+ "wish_url_charge,wish_result_one_day,wish_result_two_day,"
				+ "wish_result_three_day,wish_result_four_day,wish_result_five_day,"
				+ "wish_result_six_day,wish_result_seven_day,wish_result_eight_day,"
				+ "wish_result_nine_day,wish_result_ten_day,wish_result_charge,"
				+ "cart_url_one_day,cart_url_two_day,cart_url_three_day,"
				+ "cart_url_four_day,cart_url_five_day,cart_url_six_day,"
				+ "cart_url_seven_day,cart_url_eight_day,cart_url_nine_day,"
				+ "cart_url_ten_day,cart_url_charge,cart_result_one_day,"
				+ "cart_result_two_day,cart_result_three_day,cart_result_four_day,"
				+ "cart_result_five_day,cart_result_six_day,cart_result_seven_day,"
				+ "cart_result_eight_day,cart_result_nine_day,cart_result_ten_day,"
				+ "cart_result_charge,orderNo,orderState,email,createtime,"
				+ "one_day,two_day,three_day,four_day,five_day,six_day,seven_day,"
				+ "eight_day,nine_day,ten_day,flow_checked,flow_rate,hope_checked,hope_rate,"
				+ "favorite_checked,favorite_rate,pay_remark,procedureNum,payNum,order_type,question,ping_title,"
				+ "yasin,ysale_id,ypro_price,yp_price,ypro_key,ypro_url,ypro_title,ypro_name,siteId "
				+ " FROM task_info  WHERE  ";
		if (!StringUtils.isNullOrEmpty(email)) {
			sql += " email=? ";
		}else{
			sql += "  1=? ";
		}
		
		if (!StringUtils.isNullOrEmpty(orderState)) {
			
			if (Integer.parseInt(orderState)!=0) {
				sql += " AND orderState > 0 AND 1=?  ";
			}else {
				sql += " AND orderState=? ";
			}
		} else {
			sql += " AND 1=? ";
		}
		if (!StringUtils.isNullOrEmpty(order_type)) {
			sql += " AND order_type=? ";
		}else{
			sql += "  AND 1=? ";
		}
		sql += " ORDER BY  createtime DESC LIMIT ?,?";

		return (List<Task_info>) DBUtils.executeQuery(
				sql,
				new ResultSetHandler() {
					List<Task_info> list = new ArrayList<Task_info>();

					@Override
					public Object doHandler(ResultSet rs) throws SQLException {
						while (rs.next()) {
							Task_info task_info = new Task_info();
							task_info.setAsin(rs.getString(1));
							task_info.setSale_id(rs.getString(2));
							task_info.setPro_price(rs.getDouble(3));
							task_info.setP_price(rs.getDouble(4));
							task_info.setPro_key(rs.getString(5));
							task_info.setPro_url(rs.getString(6));
							task_info.setPro_title(rs.getString(7));
							task_info.setPro_name(rs.getString(8));
							task_info.setOrder_url_one_day(rs.getInt(9));
							task_info.setOrder_url_two_day(rs.getInt(10));
							task_info.setOrder_url_three_day(rs.getInt(11));
							task_info.setOrder_url_four_day(rs.getInt(12));
							task_info.setOrder_url_five_day(rs.getInt(13));
							task_info.setOrder_url_six_day(rs.getInt(14));
							task_info.setOrder_url_seven_day(rs.getInt(15));
							task_info.setOrder_url_eight_day(rs.getInt(16));
							task_info.setOrder_url_nine_day(rs.getInt(17));
							task_info.setOrder_url_ten_day(rs.getInt(18));
							task_info.setOrder_url_charge(rs.getDouble(19));
							task_info.setOrder_ad_one_day(rs.getInt(20));
							task_info.setOrder_ad_two_day(rs.getInt(21));
							task_info.setOrder_ad_three_day(rs.getInt(22));
							task_info.setOrder_ad_four_day(rs.getInt(23));
							task_info.setOrder_ad_five_day(rs.getInt(24));
							task_info.setOrder_ad_six_day(rs.getInt(25));
							task_info.setOrder_ad_seven_day(rs.getInt(26));
							task_info.setOrder_ad_eight_day(rs.getInt(27));
							task_info.setOrder_ad_nine_day(rs.getInt(28));
							task_info.setOrder_ad_ten_day(rs.getInt(29));
							task_info.setOrder_ad_charge(rs.getDouble(30));
							task_info.setOrder_result_one_day(rs.getInt(31));
							task_info.setOrder_result_two_day(rs.getInt(32));
							task_info.setOrder_result_three_day(rs.getInt(33));
							task_info.setOrder_result_four_day(rs.getInt(34));
							task_info.setOrder_result_five_day(rs.getInt(35));
							task_info.setOrder_result_six_day(rs.getInt(36));
							task_info.setOrder_result_seven_day(rs.getInt(37));
							task_info.setOrder_result_eight_day(rs.getInt(38));
							task_info.setOrder_result_nine_day(rs.getInt(39));
							task_info.setOrder_result_ten_day(rs.getInt(40));
							task_info.setOrder_result_charge(rs.getDouble(41));
							task_info.setReview_one_day(rs.getInt(42));
							task_info.setReview_one_day_info(rs.getString(43));
							task_info.setReview_two_day(rs.getInt(44));
							task_info.setReview_two_day_info(rs.getString(45));
							task_info.setReview_three_day(rs.getInt(46));
							task_info.setReview_three_day_info(rs.getString(47));
							task_info.setReview_four_day(rs.getInt(48));
							task_info.setReview_four_day_info(rs.getString(49));
							task_info.setReview_five_day(rs.getInt(50));
							task_info.setReview_five_day_info(rs.getString(51));
							task_info.setReview_six_day(rs.getInt(52));
							task_info.setReview_six_day_info(rs.getString(53));
							task_info.setReview_seven_day(rs.getInt(54));
							task_info.setReview_seven_day_info(rs.getString(55));
							task_info.setReview_eight_day(rs.getInt(56));
							task_info.setReview_eight_day_info(rs.getString(57));
							task_info.setReview_nine_day(rs.getInt(58));
							task_info.setReview_nine_day_info(rs.getString(59));
							task_info.setReview_ten_day(rs.getInt(60));
							task_info.setReview_ten_day_info(rs.getString(61));
							task_info.setReview_charge(rs.getDouble(62));
							task_info.setFeedback_one_day(rs.getInt(63));
							task_info.setFeedback_one_day_info(rs.getString(64));
							task_info.setFeedback_two_day(rs.getInt(65));
							task_info.setFeedback_two_day_info(rs.getString(66));
							task_info.setFeedback_three_day(rs.getInt(67));
							task_info.setFeedback_three_day_info(rs
									.getString(68));
							task_info.setFeedback_four_day(rs.getInt(69));
							task_info.setFeedback_four_day_info(rs
									.getString(70));
							task_info.setFeedback_five_day(rs.getInt(71));
							task_info.setFeedback_five_day_info(rs
									.getString(72));
							task_info.setFeedback_six_day(rs.getInt(73));
							task_info.setFeedback_six_day_info(rs.getString(74));
							task_info.setFeedback_seven_day(rs.getInt(75));
							task_info.setFeedback_seven_day_info(rs
									.getString(76));
							task_info.setFeedback_eight_day(rs.getInt(77));
							task_info.setFeedback_eight_day_info(rs
									.getString(78));
							task_info.setFeedback_nine_day(rs.getInt(79));
							task_info.setFeedback_nine_day_info(rs
									.getString(80));
							task_info.setFeedback_ten_day(rs.getInt(81));
							task_info.setFeedback_ten_day_info(rs.getString(82));
							task_info.setFeedback_charge(rs.getDouble(83));
							task_info.setFlow_url_one_day(rs.getInt(84));
							task_info.setFlow_url_two_day(rs.getInt(85));
							task_info.setFlow_url_three_day(rs.getInt(86));
							task_info.setFlow_url_four_day(rs.getInt(87));
							task_info.setFlow_url_five_day(rs.getInt(88));
							task_info.setFlow_url_six_day(rs.getInt(89));
							task_info.setFlow_url_seven_day(rs.getInt(90));
							task_info.setFlow_url_eight_day(rs.getInt(91));
							task_info.setFlow_url_nine_day(rs.getInt(92));
							task_info.setFlow_url_ten_day(rs.getInt(93));
							task_info.setFlow_url_charge(rs.getDouble(94));
							task_info.setFlow_result_one_day(rs.getInt(95));
							task_info.setFlow_result_two_day(rs.getInt(96));
							task_info.setFlow_result_three_day(rs.getInt(97));
							task_info.setFlow_result_four_day(rs.getInt(98));
							task_info.setFlow_result_five_day(rs.getInt(99));
							task_info.setFlow_result_six_day(rs.getInt(100));
							task_info.setFlow_result_seven_day(rs.getInt(101));
							task_info.setFlow_result_eight_day(rs.getInt(102));
							task_info.setFlow_result_nine_day(rs.getInt(103));
							task_info.setFlow_result_ten_day(rs.getInt(104));
							task_info.setFlow_result_charge(rs.getDouble(105));
							task_info.setFlow_ad_one_day(rs.getInt(106));
							task_info.setFlow_ad_two_day(rs.getInt(107));
							task_info.setFlow_ad_three_day(rs.getInt(108));
							task_info.setFlow_ad_four_day(rs.getInt(109));
							task_info.setFlow_ad_five_day(rs.getInt(110));
							task_info.setFlow_ad_six_day(rs.getInt(111));
							task_info.setFlow_ad_seven_day(rs.getInt(112));
							task_info.setFlow_ad_eight_day(rs.getInt(113));
							task_info.setFlow_ad_nine_day(rs.getInt(114));
							task_info.setFlow_ad_ten_day(rs.getInt(115));
							task_info.setFlow_ad_charge(rs.getDouble(116));
							task_info.setWish_url_one_day(rs.getInt(117));
							task_info.setWish_url_two_day(rs.getInt(118));
							task_info.setWish_url_three_day(rs.getInt(119));
							task_info.setWish_url_four_day(rs.getInt(120));
							task_info.setWish_url_five_day(rs.getInt(121));
							task_info.setWish_url_six_day(rs.getInt(122));
							task_info.setWish_url_seven_day(rs.getInt(123));
							task_info.setWish_url_eight_day(rs.getInt(124));
							task_info.setWish_url_nine_day(rs.getInt(125));
							task_info.setWish_url_ten_day(rs.getInt(126));
							task_info.setWish_url_charge(rs.getDouble(127));
							task_info.setWish_result_one_day(rs.getInt(128));
							task_info.setWish_result_two_day(rs.getInt(129));
							task_info.setWish_result_three_day(rs.getInt(130));
							task_info.setWish_result_four_day(rs.getInt(131));
							task_info.setWish_result_five_day(rs.getInt(132));
							task_info.setWish_result_six_day(rs.getInt(133));
							task_info.setWish_result_seven_day(rs.getInt(134));
							task_info.setWish_result_eight_day(rs.getInt(135));
							task_info.setWish_result_nine_day(rs.getInt(136));
							task_info.setWish_result_ten_day(rs.getInt(137));
							task_info.setWish_result_charge(rs.getDouble(138));
							task_info.setCart_url_one_day(rs.getInt(139));
							task_info.setCart_url_two_day(rs.getInt(140));
							task_info.setCart_url_three_day(rs.getInt(141));
							task_info.setCart_url_four_day(rs.getInt(142));
							task_info.setCart_url_five_day(rs.getInt(143));
							task_info.setCart_url_six_day(rs.getInt(144));
							task_info.setCart_url_seven_day(rs.getInt(145));
							task_info.setCart_url_eight_day(rs.getInt(146));
							task_info.setCart_url_nine_day(rs.getInt(147));
							task_info.setCart_url_ten_day(rs.getInt(148));
							task_info.setCart_url_charge(rs.getDouble(149));
							task_info.setCart_result_one_day(rs.getInt(150));
							task_info.setCart_result_two_day(rs.getInt(151));
							task_info.setCart_result_three_day(rs.getInt(152));
							task_info.setCart_result_four_day(rs.getInt(153));
							task_info.setCart_result_five_day(rs.getInt(154));
							task_info.setCart_result_six_day(rs.getInt(155));
							task_info.setCart_result_seven_day(rs.getInt(156));
							task_info.setCart_result_eight_day(rs.getInt(157));
							task_info.setCart_result_nine_day(rs.getInt(158));
							task_info.setCart_result_ten_day(rs.getInt(159));
							task_info.setCart_result_charge(rs.getDouble(160));
							task_info.setOrderNo(rs.getString(161));
							task_info.setOrderState(rs.getInt(162));
							task_info.setEmail(rs.getString(163));
							task_info.setCreatetime(rs.getLong(164));
							task_info.setOne_day(rs.getString(165));
							task_info.setTwo_day(rs.getString(166));
							task_info.setThree_day(rs.getString(167));
							task_info.setFour_day(rs.getString(168));
							task_info.setFive_day(rs.getString(169));
							task_info.setSix_day(rs.getString(170));
							task_info.setSeven_day(rs.getString(171));
							task_info.setEight_day(rs.getString(172));
							task_info.setNine_day(rs.getString(173));
							task_info.setTen_day(rs.getString(174));
							task_info.setFlow_checked(rs.getInt(175));
							task_info.setFlow_rate(rs.getDouble(176));
							task_info.setHope_checked(rs.getInt(177));
							task_info.setHope_rate(rs.getDouble(178));
							task_info.setFavorite_checked(rs.getInt(179));
							task_info.setFavorite_rate(rs.getDouble(180));
							task_info.setPay_remark(rs.getString(181));
							task_info.setProcedureNum(rs.getDouble(182));
							task_info.setPayNum(rs.getDouble(183));
							task_info.setOrder_type(rs.getInt(184));
							task_info.setQuestion(rs.getString(185));
							task_info.setPing_title(rs.getString(186));
							task_info.setYasin(rs.getString(187));
							task_info.setYsale_id(rs.getString(188));
							task_info.setYpro_price(rs.getDouble(189));
							task_info.setYp_price(rs.getDouble(190));
							task_info.setYpro_key(rs.getString(191));
							task_info.setYpro_url(rs.getString(192));
							task_info.setYpro_title(rs.getString(193));
							task_info.setYpro_name(rs.getString(194));
							task_info.setSiteId(rs.getInt(195));
							list.add(task_info);
						}
						rs.close();
						return list;
					}
				},StringUtils.isNullOrEmpty(email)?1:email,StringUtils.isNullOrEmpty(orderState) ? 1 : orderState,
						StringUtils.isNullOrEmpty(order_type)?1:order_type,
				(pageHelper.getCurrentPage() - 1) * pageHelper.getPageSize(),
				pageHelper.getPageSize());
	}
	
	
	/**
	 * 根据用户email（登录帐号）分页查询全部订单任务(后台)
	 * 
	 * @param email
	 *            pageHelper
	 * @return
	 */
	@SuppressWarnings("unchecked")
	public static List<Task_info> getList(String email, String orderState,String order_type,
			PageHelper pageHelper) {
		StringBuilder str = new StringBuilder();
		str.append("SELECT COUNT(id) FROM task_info WHERE   ");
		if (!StringUtils.isNullOrEmpty(email)) {
			str.append(" email=? ");
		}else{
			str.append(" 1=? ");
		}
		
		if (!StringUtils.isNullOrEmpty(orderState)) {
			
			
				str.append(" AND orderState=? ");
			
			
		} else {
			str.append(" AND (orderState in (1,2)) AND  1=? ");
		}
		// 根据订单类型查
		if (!StringUtils.isNullOrEmpty(order_type)) {
			str.append(" AND order_type=? ");
		}else{
			str.append(" AND 1=? ");
		}
		Integer count = Integer.parseInt(DBUtils.executeQuery(str.toString(),
				StringUtils.isNullOrEmpty(email)?1:email, 
						StringUtils.isNullOrEmpty(orderState) ? 1 : orderState,
								StringUtils.isNullOrEmpty(order_type)?1:order_type)
				.toString());
		pageHelper.setTotalCount(count); // 设置总记录数

		String sql = "SELECT  asin,sale_id,pro_price,p_price,pro_key,"
				+ "pro_url,pro_title,pro_name,order_url_one_day,order_url_two_day,"
				+ "order_url_three_day,order_url_four_day,order_url_five_day,"
				+ "order_url_six_day,order_url_seven_day,order_url_eight_day,"
				+ "order_url_nine_day,order_url_ten_day,order_url_charge,"
				+ "order_ad_one_day,order_ad_two_day,order_ad_three_day,"
				+ "order_ad_four_day,order_ad_five_day,order_ad_six_day,"
				+ "order_ad_seven_day,order_ad_eight_day,order_ad_nine_day,"
				+ "order_ad_ten_day,order_ad_charge,order_result_one_day,"
				+ "order_result_two_day,order_result_three_day,order_result_four_day,"
				+ "order_result_five_day,order_result_six_day,order_result_seven_day,"
				+ "order_result_eight_day,order_result_nine_day,order_result_ten_day,"
				+ "order_result_charge,review_one_day,review_one_day_info,"
				+ "review_two_day,review_two_day_info,review_three_day,"
				+ "review_three_day_info,review_four_day,review_four_day_info,"
				+ "review_five_day,review_five_day_info,review_six_day,"
				+ "review_six_day_info,review_seven_day,review_seven_day_info,"
				+ "review_eight_day,review_eight_day_info,review_nine_day,"
				+ "review_nine_day_info,review_ten_day,review_ten_day_info,"
				+ "review_charge,feedback_one_day,feedback_one_day_info,"
				+ "feedback_two_day,feedback_two_day_info,feedback_three_day,"
				+ "feedback_three_day_info,feedback_four_day,feedback_four_day_info,"
				+ "feedback_five_day,feedback_five_day_info,feedback_six_day,"
				+ "feedback_six_day_info,feedback_seven_day,feedback_seven_day_info,"
				+ "feedback_eight_day,feedback_eight_day_info,feedback_nine_day,"
				+ "feedback_nine_day_info,feedback_ten_day,feedback_ten_day_info,"
				+ "feedback_charge,flow_url_one_day,flow_url_two_day,"
				+ "flow_url_three_day,flow_url_four_day,flow_url_five_day,"
				+ "flow_url_six_day,flow_url_seven_day,flow_url_eight_day,"
				+ "flow_url_nine_day,flow_url_ten_day,flow_url_charge,"
				+ "flow_result_one_day,flow_result_two_day,flow_result_three_day,"
				+ "flow_result_four_day,flow_result_five_day,flow_result_six_day,"
				+ "flow_result_seven_day,flow_result_eight_day,flow_result_nine_day,"
				+ "flow_result_ten_day,flow_result_charge,flow_ad_one_day,flow_ad_two_day,"
				+ "flow_ad_three_day,flow_ad_four_day,flow_ad_five_day,flow_ad_six_day,"
				+ "flow_ad_seven_day,flow_ad_eight_day,flow_ad_nine_day,flow_ad_ten_day,"
				+ "flow_ad_charge,wish_url_one_day,"
				+ "wish_url_two_day,wish_url_three_day,wish_url_four_day,"
				+ "wish_url_five_day,wish_url_six_day,wish_url_seven_day,"
				+ "wish_url_eight_day,wish_url_nine_day,wish_url_ten_day,"
				+ "wish_url_charge,wish_result_one_day,wish_result_two_day,"
				+ "wish_result_three_day,wish_result_four_day,wish_result_five_day,"
				+ "wish_result_six_day,wish_result_seven_day,wish_result_eight_day,"
				+ "wish_result_nine_day,wish_result_ten_day,wish_result_charge,"
				+ "cart_url_one_day,cart_url_two_day,cart_url_three_day,"
				+ "cart_url_four_day,cart_url_five_day,cart_url_six_day,"
				+ "cart_url_seven_day,cart_url_eight_day,cart_url_nine_day,"
				+ "cart_url_ten_day,cart_url_charge,cart_result_one_day,"
				+ "cart_result_two_day,cart_result_three_day,cart_result_four_day,"
				+ "cart_result_five_day,cart_result_six_day,cart_result_seven_day,"
				+ "cart_result_eight_day,cart_result_nine_day,cart_result_ten_day,"
				+ "cart_result_charge,orderNo,orderState,email,createtime,"
				+ "one_day,two_day,three_day,four_day,five_day,six_day,seven_day,"
				+ "eight_day,nine_day,ten_day,flow_checked,flow_rate,hope_checked,hope_rate,"
				+ "favorite_checked,favorite_rate,pay_remark,procedureNum,payNum,order_type,question,ping_title,"
				+ "yasin,ysale_id,ypro_price,yp_price,ypro_key,ypro_url,ypro_title,ypro_name,siteId "
				+ " FROM task_info  WHERE  ";
		if (!StringUtils.isNullOrEmpty(email)) {
			sql += " email=? ";
		}else{
			sql += "  1=? ";
		}
		
		if (!StringUtils.isNullOrEmpty(orderState)) {
				sql += " AND orderState=? ";
		} else {
			sql += "AND (orderState in (1,2)) AND  1=? ";
		}
		if (!StringUtils.isNullOrEmpty(order_type)) {
			sql += " AND order_type=? ";
		}else{
			sql += "  AND 1=? ";
		}
		sql += " ORDER BY  createtime DESC LIMIT ?,?";

		return (List<Task_info>) DBUtils.executeQuery(
				sql,
				new ResultSetHandler() {
					List<Task_info> list = new ArrayList<Task_info>();

					@Override
					public Object doHandler(ResultSet rs) throws SQLException {
						while (rs.next()) {
							Task_info task_info = new Task_info();
							task_info.setAsin(rs.getString(1));
							task_info.setSale_id(rs.getString(2));
							task_info.setPro_price(rs.getDouble(3));
							task_info.setP_price(rs.getDouble(4));
							task_info.setPro_key(rs.getString(5));
							task_info.setPro_url(rs.getString(6));
							task_info.setPro_title(rs.getString(7));
							task_info.setPro_name(rs.getString(8));
							task_info.setOrder_url_one_day(rs.getInt(9));
							task_info.setOrder_url_two_day(rs.getInt(10));
							task_info.setOrder_url_three_day(rs.getInt(11));
							task_info.setOrder_url_four_day(rs.getInt(12));
							task_info.setOrder_url_five_day(rs.getInt(13));
							task_info.setOrder_url_six_day(rs.getInt(14));
							task_info.setOrder_url_seven_day(rs.getInt(15));
							task_info.setOrder_url_eight_day(rs.getInt(16));
							task_info.setOrder_url_nine_day(rs.getInt(17));
							task_info.setOrder_url_ten_day(rs.getInt(18));
							task_info.setOrder_url_charge(rs.getDouble(19));
							task_info.setOrder_ad_one_day(rs.getInt(20));
							task_info.setOrder_ad_two_day(rs.getInt(21));
							task_info.setOrder_ad_three_day(rs.getInt(22));
							task_info.setOrder_ad_four_day(rs.getInt(23));
							task_info.setOrder_ad_five_day(rs.getInt(24));
							task_info.setOrder_ad_six_day(rs.getInt(25));
							task_info.setOrder_ad_seven_day(rs.getInt(26));
							task_info.setOrder_ad_eight_day(rs.getInt(27));
							task_info.setOrder_ad_nine_day(rs.getInt(28));
							task_info.setOrder_ad_ten_day(rs.getInt(29));
							task_info.setOrder_ad_charge(rs.getDouble(30));
							task_info.setOrder_result_one_day(rs.getInt(31));
							task_info.setOrder_result_two_day(rs.getInt(32));
							task_info.setOrder_result_three_day(rs.getInt(33));
							task_info.setOrder_result_four_day(rs.getInt(34));
							task_info.setOrder_result_five_day(rs.getInt(35));
							task_info.setOrder_result_six_day(rs.getInt(36));
							task_info.setOrder_result_seven_day(rs.getInt(37));
							task_info.setOrder_result_eight_day(rs.getInt(38));
							task_info.setOrder_result_nine_day(rs.getInt(39));
							task_info.setOrder_result_ten_day(rs.getInt(40));
							task_info.setOrder_result_charge(rs.getDouble(41));
							task_info.setReview_one_day(rs.getInt(42));
							task_info.setReview_one_day_info(rs.getString(43));
							task_info.setReview_two_day(rs.getInt(44));
							task_info.setReview_two_day_info(rs.getString(45));
							task_info.setReview_three_day(rs.getInt(46));
							task_info.setReview_three_day_info(rs.getString(47));
							task_info.setReview_four_day(rs.getInt(48));
							task_info.setReview_four_day_info(rs.getString(49));
							task_info.setReview_five_day(rs.getInt(50));
							task_info.setReview_five_day_info(rs.getString(51));
							task_info.setReview_six_day(rs.getInt(52));
							task_info.setReview_six_day_info(rs.getString(53));
							task_info.setReview_seven_day(rs.getInt(54));
							task_info.setReview_seven_day_info(rs.getString(55));
							task_info.setReview_eight_day(rs.getInt(56));
							task_info.setReview_eight_day_info(rs.getString(57));
							task_info.setReview_nine_day(rs.getInt(58));
							task_info.setReview_nine_day_info(rs.getString(59));
							task_info.setReview_ten_day(rs.getInt(60));
							task_info.setReview_ten_day_info(rs.getString(61));
							task_info.setReview_charge(rs.getDouble(62));
							task_info.setFeedback_one_day(rs.getInt(63));
							task_info.setFeedback_one_day_info(rs.getString(64));
							task_info.setFeedback_two_day(rs.getInt(65));
							task_info.setFeedback_two_day_info(rs.getString(66));
							task_info.setFeedback_three_day(rs.getInt(67));
							task_info.setFeedback_three_day_info(rs
									.getString(68));
							task_info.setFeedback_four_day(rs.getInt(69));
							task_info.setFeedback_four_day_info(rs
									.getString(70));
							task_info.setFeedback_five_day(rs.getInt(71));
							task_info.setFeedback_five_day_info(rs
									.getString(72));
							task_info.setFeedback_six_day(rs.getInt(73));
							task_info.setFeedback_six_day_info(rs.getString(74));
							task_info.setFeedback_seven_day(rs.getInt(75));
							task_info.setFeedback_seven_day_info(rs
									.getString(76));
							task_info.setFeedback_eight_day(rs.getInt(77));
							task_info.setFeedback_eight_day_info(rs
									.getString(78));
							task_info.setFeedback_nine_day(rs.getInt(79));
							task_info.setFeedback_nine_day_info(rs
									.getString(80));
							task_info.setFeedback_ten_day(rs.getInt(81));
							task_info.setFeedback_ten_day_info(rs.getString(82));
							task_info.setFeedback_charge(rs.getDouble(83));
							task_info.setFlow_url_one_day(rs.getInt(84));
							task_info.setFlow_url_two_day(rs.getInt(85));
							task_info.setFlow_url_three_day(rs.getInt(86));
							task_info.setFlow_url_four_day(rs.getInt(87));
							task_info.setFlow_url_five_day(rs.getInt(88));
							task_info.setFlow_url_six_day(rs.getInt(89));
							task_info.setFlow_url_seven_day(rs.getInt(90));
							task_info.setFlow_url_eight_day(rs.getInt(91));
							task_info.setFlow_url_nine_day(rs.getInt(92));
							task_info.setFlow_url_ten_day(rs.getInt(93));
							task_info.setFlow_url_charge(rs.getDouble(94));
							task_info.setFlow_result_one_day(rs.getInt(95));
							task_info.setFlow_result_two_day(rs.getInt(96));
							task_info.setFlow_result_three_day(rs.getInt(97));
							task_info.setFlow_result_four_day(rs.getInt(98));
							task_info.setFlow_result_five_day(rs.getInt(99));
							task_info.setFlow_result_six_day(rs.getInt(100));
							task_info.setFlow_result_seven_day(rs.getInt(101));
							task_info.setFlow_result_eight_day(rs.getInt(102));
							task_info.setFlow_result_nine_day(rs.getInt(103));
							task_info.setFlow_result_ten_day(rs.getInt(104));
							task_info.setFlow_result_charge(rs.getDouble(105));
							task_info.setFlow_ad_one_day(rs.getInt(106));
							task_info.setFlow_ad_two_day(rs.getInt(107));
							task_info.setFlow_ad_three_day(rs.getInt(108));
							task_info.setFlow_ad_four_day(rs.getInt(109));
							task_info.setFlow_ad_five_day(rs.getInt(110));
							task_info.setFlow_ad_six_day(rs.getInt(111));
							task_info.setFlow_ad_seven_day(rs.getInt(112));
							task_info.setFlow_ad_eight_day(rs.getInt(113));
							task_info.setFlow_ad_nine_day(rs.getInt(114));
							task_info.setFlow_ad_ten_day(rs.getInt(115));
							task_info.setFlow_ad_charge(rs.getDouble(116));
							task_info.setWish_url_one_day(rs.getInt(117));
							task_info.setWish_url_two_day(rs.getInt(118));
							task_info.setWish_url_three_day(rs.getInt(119));
							task_info.setWish_url_four_day(rs.getInt(120));
							task_info.setWish_url_five_day(rs.getInt(121));
							task_info.setWish_url_six_day(rs.getInt(122));
							task_info.setWish_url_seven_day(rs.getInt(123));
							task_info.setWish_url_eight_day(rs.getInt(124));
							task_info.setWish_url_nine_day(rs.getInt(125));
							task_info.setWish_url_ten_day(rs.getInt(126));
							task_info.setWish_url_charge(rs.getDouble(127));
							task_info.setWish_result_one_day(rs.getInt(128));
							task_info.setWish_result_two_day(rs.getInt(129));
							task_info.setWish_result_three_day(rs.getInt(130));
							task_info.setWish_result_four_day(rs.getInt(131));
							task_info.setWish_result_five_day(rs.getInt(132));
							task_info.setWish_result_six_day(rs.getInt(133));
							task_info.setWish_result_seven_day(rs.getInt(134));
							task_info.setWish_result_eight_day(rs.getInt(135));
							task_info.setWish_result_nine_day(rs.getInt(136));
							task_info.setWish_result_ten_day(rs.getInt(137));
							task_info.setWish_result_charge(rs.getDouble(138));
							task_info.setCart_url_one_day(rs.getInt(139));
							task_info.setCart_url_two_day(rs.getInt(140));
							task_info.setCart_url_three_day(rs.getInt(141));
							task_info.setCart_url_four_day(rs.getInt(142));
							task_info.setCart_url_five_day(rs.getInt(143));
							task_info.setCart_url_six_day(rs.getInt(144));
							task_info.setCart_url_seven_day(rs.getInt(145));
							task_info.setCart_url_eight_day(rs.getInt(146));
							task_info.setCart_url_nine_day(rs.getInt(147));
							task_info.setCart_url_ten_day(rs.getInt(148));
							task_info.setCart_url_charge(rs.getDouble(149));
							task_info.setCart_result_one_day(rs.getInt(150));
							task_info.setCart_result_two_day(rs.getInt(151));
							task_info.setCart_result_three_day(rs.getInt(152));
							task_info.setCart_result_four_day(rs.getInt(153));
							task_info.setCart_result_five_day(rs.getInt(154));
							task_info.setCart_result_six_day(rs.getInt(155));
							task_info.setCart_result_seven_day(rs.getInt(156));
							task_info.setCart_result_eight_day(rs.getInt(157));
							task_info.setCart_result_nine_day(rs.getInt(158));
							task_info.setCart_result_ten_day(rs.getInt(159));
							task_info.setCart_result_charge(rs.getDouble(160));
							task_info.setOrderNo(rs.getString(161));
							task_info.setOrderState(rs.getInt(162));
							task_info.setEmail(rs.getString(163));
							task_info.setCreatetime(rs.getLong(164));
							task_info.setOne_day(rs.getString(165));
							task_info.setTwo_day(rs.getString(166));
							task_info.setThree_day(rs.getString(167));
							task_info.setFour_day(rs.getString(168));
							task_info.setFive_day(rs.getString(169));
							task_info.setSix_day(rs.getString(170));
							task_info.setSeven_day(rs.getString(171));
							task_info.setEight_day(rs.getString(172));
							task_info.setNine_day(rs.getString(173));
							task_info.setTen_day(rs.getString(174));
							task_info.setFlow_checked(rs.getInt(175));
							task_info.setFlow_rate(rs.getDouble(176));
							task_info.setHope_checked(rs.getInt(177));
							task_info.setHope_rate(rs.getDouble(178));
							task_info.setFavorite_checked(rs.getInt(179));
							task_info.setFavorite_rate(rs.getDouble(180));
							task_info.setPay_remark(rs.getString(181));
							task_info.setProcedureNum(rs.getDouble(182));
							task_info.setPayNum(rs.getDouble(183));
							task_info.setOrder_type(rs.getInt(184));
							task_info.setQuestion(rs.getString(185));
							task_info.setPing_title(rs.getString(186));
							task_info.setYasin(rs.getString(187));
							task_info.setYsale_id(rs.getString(188));
							task_info.setYpro_price(rs.getDouble(189));
							task_info.setYp_price(rs.getDouble(190));
							task_info.setYpro_key(rs.getString(191));
							task_info.setYpro_url(rs.getString(192));
							task_info.setYpro_title(rs.getString(193));
							task_info.setYpro_name(rs.getString(194));
							task_info.setSiteId(rs.getInt(195));
							list.add(task_info);
						}
						rs.close();
						return list;
					}
				},StringUtils.isNullOrEmpty(email)?1:email,StringUtils.isNullOrEmpty(orderState) ? 1 : orderState,
						StringUtils.isNullOrEmpty(order_type)?1:order_type,
				(pageHelper.getCurrentPage() - 1) * pageHelper.getPageSize(),
				pageHelper.getPageSize());
	}
	
	
	/**
	 * 搜索---分页查询全部订单任务(后台)
	 * 
	 * @param email
	 *            pageHelper
	 * @return
	 */
	@SuppressWarnings("unchecked")
	public static List<Task_info> getListSearch(String email, String order_type,String key,
			PageHelper pageHelper) {
		StringBuilder str = new StringBuilder();
		str.append("SELECT COUNT(id) FROM task_info WHERE   ");
		if (!StringUtils.isNullOrEmpty(email)) {
			str.append(" email=? ");
		}else{
			str.append(" 1=? ");
		}
		if (!StringUtils.isNullOrEmpty(order_type)) {
			str.append(" AND order_type=? ");
		}else{
			str.append(" AND 1=? ");
		}
		if (!StringUtils.isNullOrEmpty(key)) {
			str.append(" AND (orderNo like ? OR asin like ? OR pro_name like ?)");
		} else {
			str.append(" AND 1=? ");
		}
		String key1 = StringUtils.isNullOrEmpty(key) ? "1" : "%"+key+"%";
		Integer count = Integer.parseInt(DBUtils.executeQuery(str.toString(),
				StringUtils.isNullOrEmpty(email)?1:email,StringUtils.isNullOrEmpty(order_type)?1:order_type, key1,key1,key1)
				.toString());
		pageHelper.setTotalCount(count); // 设置总记录数

		String sql = "SELECT  asin,sale_id,pro_price,p_price,pro_key,"
				+ "pro_url,pro_title,pro_name,order_url_one_day,order_url_two_day,"
				+ "order_url_three_day,order_url_four_day,order_url_five_day,"
				+ "order_url_six_day,order_url_seven_day,order_url_eight_day,"
				+ "order_url_nine_day,order_url_ten_day,order_url_charge,"
				+ "order_ad_one_day,order_ad_two_day,order_ad_three_day,"
				+ "order_ad_four_day,order_ad_five_day,order_ad_six_day,"
				+ "order_ad_seven_day,order_ad_eight_day,order_ad_nine_day,"
				+ "order_ad_ten_day,order_ad_charge,order_result_one_day,"
				+ "order_result_two_day,order_result_three_day,order_result_four_day,"
				+ "order_result_five_day,order_result_six_day,order_result_seven_day,"
				+ "order_result_eight_day,order_result_nine_day,order_result_ten_day,"
				+ "order_result_charge,review_one_day,review_one_day_info,"
				+ "review_two_day,review_two_day_info,review_three_day,"
				+ "review_three_day_info,review_four_day,review_four_day_info,"
				+ "review_five_day,review_five_day_info,review_six_day,"
				+ "review_six_day_info,review_seven_day,review_seven_day_info,"
				+ "review_eight_day,review_eight_day_info,review_nine_day,"
				+ "review_nine_day_info,review_ten_day,review_ten_day_info,"
				+ "review_charge,feedback_one_day,feedback_one_day_info,"
				+ "feedback_two_day,feedback_two_day_info,feedback_three_day,"
				+ "feedback_three_day_info,feedback_four_day,feedback_four_day_info,"
				+ "feedback_five_day,feedback_five_day_info,feedback_six_day,"
				+ "feedback_six_day_info,feedback_seven_day,feedback_seven_day_info,"
				+ "feedback_eight_day,feedback_eight_day_info,feedback_nine_day,"
				+ "feedback_nine_day_info,feedback_ten_day,feedback_ten_day_info,"
				+ "feedback_charge,flow_url_one_day,flow_url_two_day,"
				+ "flow_url_three_day,flow_url_four_day,flow_url_five_day,"
				+ "flow_url_six_day,flow_url_seven_day,flow_url_eight_day,"
				+ "flow_url_nine_day,flow_url_ten_day,flow_url_charge,"
				+ "flow_result_one_day,flow_result_two_day,flow_result_three_day,"
				+ "flow_result_four_day,flow_result_five_day,flow_result_six_day,"
				+ "flow_result_seven_day,flow_result_eight_day,flow_result_nine_day,"
				+ "flow_result_ten_day,flow_result_charge,flow_ad_one_day,flow_ad_two_day,"
				+ "flow_ad_three_day,flow_ad_four_day,flow_ad_five_day,flow_ad_six_day,"
				+ "flow_ad_seven_day,flow_ad_eight_day,flow_ad_nine_day,flow_ad_ten_day,"
				+ "flow_ad_charge,wish_url_one_day,"
				+ "wish_url_two_day,wish_url_three_day,wish_url_four_day,"
				+ "wish_url_five_day,wish_url_six_day,wish_url_seven_day,"
				+ "wish_url_eight_day,wish_url_nine_day,wish_url_ten_day,"
				+ "wish_url_charge,wish_result_one_day,wish_result_two_day,"
				+ "wish_result_three_day,wish_result_four_day,wish_result_five_day,"
				+ "wish_result_six_day,wish_result_seven_day,wish_result_eight_day,"
				+ "wish_result_nine_day,wish_result_ten_day,wish_result_charge,"
				+ "cart_url_one_day,cart_url_two_day,cart_url_three_day,"
				+ "cart_url_four_day,cart_url_five_day,cart_url_six_day,"
				+ "cart_url_seven_day,cart_url_eight_day,cart_url_nine_day,"
				+ "cart_url_ten_day,cart_url_charge,cart_result_one_day,"
				+ "cart_result_two_day,cart_result_three_day,cart_result_four_day,"
				+ "cart_result_five_day,cart_result_six_day,cart_result_seven_day,"
				+ "cart_result_eight_day,cart_result_nine_day,cart_result_ten_day,"
				+ "cart_result_charge,orderNo,orderState,email,createtime,"
				+ "one_day,two_day,three_day,four_day,five_day,six_day,seven_day,"
				+ "eight_day,nine_day,ten_day,flow_checked,flow_rate,hope_checked,hope_rate,"
				+ "favorite_checked,favorite_rate,pay_remark,procedureNum,payNum,order_type,question,ping_title,"
				+ "yasin,ysale_id,ypro_price,yp_price,ypro_key,ypro_url,ypro_title,ypro_name,siteId "
				+ " FROM task_info  WHERE  ";
		if (!StringUtils.isNullOrEmpty(email)) {
			sql += " email=? ";
		}else{
			sql += "  1=? ";
		}
		if (!StringUtils.isNullOrEmpty(order_type)) {
			sql += " AND order_type=? ";
		}else{
			sql += "  AND 1=? ";
		}
		if (!StringUtils.isNullOrEmpty(key)) {
			sql += " AND (orderNo like ? or asin like ? or pro_name like ?)";
		} else {
			sql += " AND 1=? ";
		}
		sql += " ORDER BY  createtime DESC LIMIT ?,?";

		return (List<Task_info>) DBUtils.executeQuery(
				sql,
				new ResultSetHandler() {
					List<Task_info> list = new ArrayList<Task_info>();

					@Override
					public Object doHandler(ResultSet rs) throws SQLException {
						while (rs.next()) {
							Task_info task_info = new Task_info();
							task_info.setAsin(rs.getString(1));
							task_info.setSale_id(rs.getString(2));
							task_info.setPro_price(rs.getDouble(3));
							task_info.setP_price(rs.getDouble(4));
							task_info.setPro_key(rs.getString(5));
							task_info.setPro_url(rs.getString(6));
							task_info.setPro_title(rs.getString(7));
							task_info.setPro_name(rs.getString(8));
							task_info.setOrder_url_one_day(rs.getInt(9));
							task_info.setOrder_url_two_day(rs.getInt(10));
							task_info.setOrder_url_three_day(rs.getInt(11));
							task_info.setOrder_url_four_day(rs.getInt(12));
							task_info.setOrder_url_five_day(rs.getInt(13));
							task_info.setOrder_url_six_day(rs.getInt(14));
							task_info.setOrder_url_seven_day(rs.getInt(15));
							task_info.setOrder_url_eight_day(rs.getInt(16));
							task_info.setOrder_url_nine_day(rs.getInt(17));
							task_info.setOrder_url_ten_day(rs.getInt(18));
							task_info.setOrder_url_charge(rs.getDouble(19));
							task_info.setOrder_ad_one_day(rs.getInt(20));
							task_info.setOrder_ad_two_day(rs.getInt(21));
							task_info.setOrder_ad_three_day(rs.getInt(22));
							task_info.setOrder_ad_four_day(rs.getInt(23));
							task_info.setOrder_ad_five_day(rs.getInt(24));
							task_info.setOrder_ad_six_day(rs.getInt(25));
							task_info.setOrder_ad_seven_day(rs.getInt(26));
							task_info.setOrder_ad_eight_day(rs.getInt(27));
							task_info.setOrder_ad_nine_day(rs.getInt(28));
							task_info.setOrder_ad_ten_day(rs.getInt(29));
							task_info.setOrder_ad_charge(rs.getDouble(30));
							task_info.setOrder_result_one_day(rs.getInt(31));
							task_info.setOrder_result_two_day(rs.getInt(32));
							task_info.setOrder_result_three_day(rs.getInt(33));
							task_info.setOrder_result_four_day(rs.getInt(34));
							task_info.setOrder_result_five_day(rs.getInt(35));
							task_info.setOrder_result_six_day(rs.getInt(36));
							task_info.setOrder_result_seven_day(rs.getInt(37));
							task_info.setOrder_result_eight_day(rs.getInt(38));
							task_info.setOrder_result_nine_day(rs.getInt(39));
							task_info.setOrder_result_ten_day(rs.getInt(40));
							task_info.setOrder_result_charge(rs.getDouble(41));
							task_info.setReview_one_day(rs.getInt(42));
							task_info.setReview_one_day_info(rs.getString(43));
							task_info.setReview_two_day(rs.getInt(44));
							task_info.setReview_two_day_info(rs.getString(45));
							task_info.setReview_three_day(rs.getInt(46));
							task_info.setReview_three_day_info(rs.getString(47));
							task_info.setReview_four_day(rs.getInt(48));
							task_info.setReview_four_day_info(rs.getString(49));
							task_info.setReview_five_day(rs.getInt(50));
							task_info.setReview_five_day_info(rs.getString(51));
							task_info.setReview_six_day(rs.getInt(52));
							task_info.setReview_six_day_info(rs.getString(53));
							task_info.setReview_seven_day(rs.getInt(54));
							task_info.setReview_seven_day_info(rs.getString(55));
							task_info.setReview_eight_day(rs.getInt(56));
							task_info.setReview_eight_day_info(rs.getString(57));
							task_info.setReview_nine_day(rs.getInt(58));
							task_info.setReview_nine_day_info(rs.getString(59));
							task_info.setReview_ten_day(rs.getInt(60));
							task_info.setReview_ten_day_info(rs.getString(61));
							task_info.setReview_charge(rs.getDouble(62));
							task_info.setFeedback_one_day(rs.getInt(63));
							task_info.setFeedback_one_day_info(rs.getString(64));
							task_info.setFeedback_two_day(rs.getInt(65));
							task_info.setFeedback_two_day_info(rs.getString(66));
							task_info.setFeedback_three_day(rs.getInt(67));
							task_info.setFeedback_three_day_info(rs
									.getString(68));
							task_info.setFeedback_four_day(rs.getInt(69));
							task_info.setFeedback_four_day_info(rs
									.getString(70));
							task_info.setFeedback_five_day(rs.getInt(71));
							task_info.setFeedback_five_day_info(rs
									.getString(72));
							task_info.setFeedback_six_day(rs.getInt(73));
							task_info.setFeedback_six_day_info(rs.getString(74));
							task_info.setFeedback_seven_day(rs.getInt(75));
							task_info.setFeedback_seven_day_info(rs
									.getString(76));
							task_info.setFeedback_eight_day(rs.getInt(77));
							task_info.setFeedback_eight_day_info(rs
									.getString(78));
							task_info.setFeedback_nine_day(rs.getInt(79));
							task_info.setFeedback_nine_day_info(rs
									.getString(80));
							task_info.setFeedback_ten_day(rs.getInt(81));
							task_info.setFeedback_ten_day_info(rs.getString(82));
							task_info.setFeedback_charge(rs.getDouble(83));
							task_info.setFlow_url_one_day(rs.getInt(84));
							task_info.setFlow_url_two_day(rs.getInt(85));
							task_info.setFlow_url_three_day(rs.getInt(86));
							task_info.setFlow_url_four_day(rs.getInt(87));
							task_info.setFlow_url_five_day(rs.getInt(88));
							task_info.setFlow_url_six_day(rs.getInt(89));
							task_info.setFlow_url_seven_day(rs.getInt(90));
							task_info.setFlow_url_eight_day(rs.getInt(91));
							task_info.setFlow_url_nine_day(rs.getInt(92));
							task_info.setFlow_url_ten_day(rs.getInt(93));
							task_info.setFlow_url_charge(rs.getDouble(94));
							task_info.setFlow_result_one_day(rs.getInt(95));
							task_info.setFlow_result_two_day(rs.getInt(96));
							task_info.setFlow_result_three_day(rs.getInt(97));
							task_info.setFlow_result_four_day(rs.getInt(98));
							task_info.setFlow_result_five_day(rs.getInt(99));
							task_info.setFlow_result_six_day(rs.getInt(100));
							task_info.setFlow_result_seven_day(rs.getInt(101));
							task_info.setFlow_result_eight_day(rs.getInt(102));
							task_info.setFlow_result_nine_day(rs.getInt(103));
							task_info.setFlow_result_ten_day(rs.getInt(104));
							task_info.setFlow_result_charge(rs.getDouble(105));
							task_info.setFlow_ad_one_day(rs.getInt(106));
							task_info.setFlow_ad_two_day(rs.getInt(107));
							task_info.setFlow_ad_three_day(rs.getInt(108));
							task_info.setFlow_ad_four_day(rs.getInt(109));
							task_info.setFlow_ad_five_day(rs.getInt(110));
							task_info.setFlow_ad_six_day(rs.getInt(111));
							task_info.setFlow_ad_seven_day(rs.getInt(112));
							task_info.setFlow_ad_eight_day(rs.getInt(113));
							task_info.setFlow_ad_nine_day(rs.getInt(114));
							task_info.setFlow_ad_ten_day(rs.getInt(115));
							task_info.setFlow_ad_charge(rs.getDouble(116));
							task_info.setWish_url_one_day(rs.getInt(117));
							task_info.setWish_url_two_day(rs.getInt(118));
							task_info.setWish_url_three_day(rs.getInt(119));
							task_info.setWish_url_four_day(rs.getInt(120));
							task_info.setWish_url_five_day(rs.getInt(121));
							task_info.setWish_url_six_day(rs.getInt(122));
							task_info.setWish_url_seven_day(rs.getInt(123));
							task_info.setWish_url_eight_day(rs.getInt(124));
							task_info.setWish_url_nine_day(rs.getInt(125));
							task_info.setWish_url_ten_day(rs.getInt(126));
							task_info.setWish_url_charge(rs.getDouble(127));
							task_info.setWish_result_one_day(rs.getInt(128));
							task_info.setWish_result_two_day(rs.getInt(129));
							task_info.setWish_result_three_day(rs.getInt(130));
							task_info.setWish_result_four_day(rs.getInt(131));
							task_info.setWish_result_five_day(rs.getInt(132));
							task_info.setWish_result_six_day(rs.getInt(133));
							task_info.setWish_result_seven_day(rs.getInt(134));
							task_info.setWish_result_eight_day(rs.getInt(135));
							task_info.setWish_result_nine_day(rs.getInt(136));
							task_info.setWish_result_ten_day(rs.getInt(137));
							task_info.setWish_result_charge(rs.getDouble(138));
							task_info.setCart_url_one_day(rs.getInt(139));
							task_info.setCart_url_two_day(rs.getInt(140));
							task_info.setCart_url_three_day(rs.getInt(141));
							task_info.setCart_url_four_day(rs.getInt(142));
							task_info.setCart_url_five_day(rs.getInt(143));
							task_info.setCart_url_six_day(rs.getInt(144));
							task_info.setCart_url_seven_day(rs.getInt(145));
							task_info.setCart_url_eight_day(rs.getInt(146));
							task_info.setCart_url_nine_day(rs.getInt(147));
							task_info.setCart_url_ten_day(rs.getInt(148));
							task_info.setCart_url_charge(rs.getDouble(149));
							task_info.setCart_result_one_day(rs.getInt(150));
							task_info.setCart_result_two_day(rs.getInt(151));
							task_info.setCart_result_three_day(rs.getInt(152));
							task_info.setCart_result_four_day(rs.getInt(153));
							task_info.setCart_result_five_day(rs.getInt(154));
							task_info.setCart_result_six_day(rs.getInt(155));
							task_info.setCart_result_seven_day(rs.getInt(156));
							task_info.setCart_result_eight_day(rs.getInt(157));
							task_info.setCart_result_nine_day(rs.getInt(158));
							task_info.setCart_result_ten_day(rs.getInt(159));
							task_info.setCart_result_charge(rs.getDouble(160));
							task_info.setOrderNo(rs.getString(161));
							task_info.setOrderState(rs.getInt(162));
							task_info.setEmail(rs.getString(163));
							task_info.setCreatetime(rs.getLong(164));
							task_info.setOne_day(rs.getString(165));
							task_info.setTwo_day(rs.getString(166));
							task_info.setThree_day(rs.getString(167));
							task_info.setFour_day(rs.getString(168));
							task_info.setFive_day(rs.getString(169));
							task_info.setSix_day(rs.getString(170));
							task_info.setSeven_day(rs.getString(171));
							task_info.setEight_day(rs.getString(172));
							task_info.setNine_day(rs.getString(173));
							task_info.setTen_day(rs.getString(174));
							task_info.setFlow_checked(rs.getInt(175));
							task_info.setFlow_rate(rs.getDouble(176));
							task_info.setHope_checked(rs.getInt(177));
							task_info.setHope_rate(rs.getDouble(178));
							task_info.setFavorite_checked(rs.getInt(179));
							task_info.setFavorite_rate(rs.getDouble(180));
							task_info.setPay_remark(rs.getString(181));
							task_info.setProcedureNum(rs.getDouble(182));
							task_info.setPayNum(rs.getDouble(183));
							task_info.setOrder_type(rs.getInt(184));
							task_info.setQuestion(rs.getString(185));
							task_info.setPing_title(rs.getString(186));
							task_info.setYasin(rs.getString(187));
							task_info.setYsale_id(rs.getString(188));
							task_info.setYpro_price(rs.getDouble(189));
							task_info.setYp_price(rs.getDouble(190));
							task_info.setYpro_key(rs.getString(191));
							task_info.setYpro_url(rs.getString(192));
							task_info.setYpro_title(rs.getString(193));
							task_info.setYpro_name(rs.getString(194));
							task_info.setSiteId(rs.getInt(195));
							list.add(task_info);
						}
						rs.close();
						return list;
					}
				},StringUtils.isNullOrEmpty(email)?1:email,StringUtils.isNullOrEmpty(order_type)?1:order_type,key1,key1,key1,
				(pageHelper.getCurrentPage() - 1) * pageHelper.getPageSize(),
				pageHelper.getPageSize());
	}

	
	/**
	 * 删除订单任务
	 * 
	 * @param
	 * @return
	 */
	public static boolean delete(String orderNo) {
		String sql = "DELETE FROM task_info WHERE orderNo=?";
		return DBUtils.executeUpdate(sql, orderNo) > 0;
	}

	/**
	 * 修改订单任务
	 * 
	 * @param
	 * @return
	 */
	public static boolean update(Task_info task_info) {
		String sql = "UPDATE task_info SET "
				+ "asin=?,sale_id=?,pro_price=?,p_price=?,pro_key=?,"
				+ "pro_url=?,pro_title=?,pro_name=?,order_url_one_day=?,order_url_two_day=?,"
				+ "order_url_three_day=?,order_url_four_day=?,order_url_five_day=?,"
				+ "order_url_six_day=?,order_url_seven_day=?,order_url_eight_day=?,"
				+ "order_url_nine_day=?,order_url_ten_day=?,order_url_charge=?,"
				+ "order_ad_one_day=?,order_ad_two_day=?,order_ad_three_day=?,"
				+ "order_ad_four_day=?,order_ad_five_day=?,order_ad_six_day=?,"
				+ "order_ad_seven_day=?,order_ad_eight_day=?,order_ad_nine_day=?,"
				+ "order_ad_ten_day=?,order_ad_charge=?,order_result_one_day=?,"
				+ "order_result_two_day=?,order_result_three_day=?,order_result_four_day=?,"
				+ "order_result_five_day=?,order_result_six_day=?,order_result_seven_day=?,"
				+ "order_result_eight_day=?,order_result_nine_day=?,order_result_ten_day=?,"
				+ "order_result_charge=?,review_one_day=?,review_one_day_info=?,"
				+ "review_two_day=?,review_two_day_info=?,review_three_day=?,"
				+ "review_three_day_info=?,review_four_day=?,review_four_day_info=?,"
				+ "review_five_day=?,review_five_day_info=?,review_six_day=?,"
				+ "review_six_day_info=?,review_seven_day=?,review_seven_day_info=?,"
				+ "review_eight_day=?,review_eight_day_info=?,review_nine_day=?,"
				+ "review_nine_day_info=?,review_ten_day=?,review_ten_day_info=?,"
				+ "review_charge=?,feedback_one_day=?,feedback_one_day_info=?,"
				+ "feedback_two_day=?,feedback_two_day_info=?,feedback_three_day=?,"
				+ "feedback_three_day_info=?,feedback_four_day=?,feedback_four_day_info=?,"
				+ "feedback_five_day=?,feedback_five_day_info=?,feedback_six_day=?,"
				+ "feedback_six_day_info=?,feedback_seven_day=?,feedback_seven_day_info=?,"
				+ "feedback_eight_day=?,feedback_eight_day_info=?,feedback_nine_day=?,"
				+ "feedback_nine_day_info=?,feedback_ten_day=?,feedback_ten_day_info=?,"
				+ "feedback_charge=?,flow_url_one_day=?,flow_url_two_day=?,"
				+ "flow_url_three_day=?,flow_url_four_day=?,flow_url_five_day=?,"
				+ "flow_url_six_day=?,flow_url_seven_day=?,flow_url_eight_day=?,"
				+ "flow_url_nine_day=?,flow_url_ten_day=?,flow_url_charge=?,"
				+ "flow_result_one_day=?,flow_result_two_day=?,flow_result_three_day=?,"
				+ "flow_result_four_day=?,flow_result_five_day=?,flow_result_six_day=?,"
				+ "flow_result_seven_day=?,flow_result_eight_day=?,flow_result_nine_day=?,"
				+ "flow_result_ten_day=?,flow_result_charge=?,flow_ad_one_day=?,flow_ad_two_day=?,"
				+ "flow_ad_three_day=?,flow_ad_four_day=?,flow_ad_five_day=?,flow_ad_six_day=?,"
				+ "flow_ad_seven_day=?,flow_ad_eight_day=?,flow_ad_nine_day=?,flow_ad_ten_day=?,"
				+ "flow_ad_charge=?,wish_url_one_day=?,"
				+ "wish_url_two_day=?,wish_url_three_day=?,wish_url_four_day=?,"
				+ "wish_url_five_day=?,wish_url_six_day=?,wish_url_seven_day=?,"
				+ "wish_url_eight_day=?,wish_url_nine_day=?,wish_url_ten_day=?,"
				+ "wish_url_charge=?,wish_result_one_day=?,wish_result_two_day=?,"
				+ "wish_result_three_day=?,wish_result_four_day=?,wish_result_five_day=?,"
				+ "wish_result_six_day=?,wish_result_seven_day=?,wish_result_eight_day=?,"
				+ "wish_result_nine_day=?,wish_result_ten_day=?,wish_result_charge=?,"
				+ "cart_url_one_day=?,cart_url_two_day=?,cart_url_three_day=?,"
				+ "cart_url_four_day=?,cart_url_five_day=?,cart_url_six_day=?,"
				+ "cart_url_seven_day=?,cart_url_eight_day=?,cart_url_nine_day=?,"
				+ "cart_url_ten_day=?,cart_url_charge=?,cart_result_one_day=?,"
				+ "cart_result_two_day=?,cart_result_three_day=?,cart_result_four_day=?,"
				+ "cart_result_five_day=?,cart_result_six_day=?,cart_result_seven_day=?,"
				+ "cart_result_eight_day=?,cart_result_nine_day=?,cart_result_ten_day=?,"
				+ "cart_result_charge=?,createtime=?,"
				+ "flow_checked=?,flow_rate=?,hope_checked=?,"
				+ "hope_rate=?,favorite_checked=?,favorite_rate=?,pay_remark=?,"
				+ "procedureNum=?,payNum=?,orderState=?,order_check=?,question=?,ping_title=?,"
				+ "yasin=?,ysale_id=?,ypro_price=?,yp_price=?,ypro_key=?,ypro_url=?,"
				+ "ypro_title=?,ypro_name=?,siteId=?"
				+ "  WHERE orderNo=?";
		return DBUtils.executeUpdate(sql, 
				task_info.getAsin(),
				task_info.getSale_id(), 
				task_info.getPro_price(),
				task_info.getP_price(), 
				task_info.getPro_key(),
				task_info.getPro_url(), 
				task_info.getPro_title(),
				task_info.getPro_name(), 
				task_info.getOrder_url_one_day(),
				task_info.getOrder_url_two_day(),
				task_info.getOrder_url_three_day(),
				task_info.getOrder_url_four_day(),
				task_info.getOrder_url_five_day(),
				task_info.getOrder_url_six_day(),
				task_info.getOrder_url_seven_day(),
				task_info.getOrder_url_eight_day(),
				task_info.getOrder_url_nine_day(),
				task_info.getOrder_url_ten_day(),
				task_info.getOrder_url_charge(),
				task_info.getOrder_ad_one_day(),
				task_info.getOrder_ad_two_day(),
				task_info.getOrder_ad_three_day(),
				task_info.getOrder_ad_four_day(),
				task_info.getOrder_ad_five_day(),
				task_info.getOrder_ad_six_day(),
				task_info.getOrder_ad_seven_day(),
				task_info.getOrder_ad_eight_day(),
				task_info.getOrder_ad_nine_day(),
				task_info.getOrder_ad_ten_day(),
				task_info.getOrder_ad_charge(),
				task_info.getOrder_result_one_day(),
				task_info.getOrder_result_two_day(),
				task_info.getOrder_result_three_day(),
				task_info.getOrder_result_four_day(),
				task_info.getOrder_result_five_day(),
				task_info.getOrder_result_six_day(),
				task_info.getOrder_result_seven_day(),
				task_info.getOrder_result_eight_day(),
				task_info.getOrder_result_nine_day(),
				task_info.getOrder_result_ten_day(),
				task_info.getOrder_result_charge(),
				task_info.getReview_one_day(),
				task_info.getReview_one_day_info(),
				task_info.getReview_two_day(),
				task_info.getReview_two_day_info(),
				task_info.getReview_three_day(),
				task_info.getReview_three_day_info(),
				task_info.getReview_four_day(),
				task_info.getReview_four_day_info(),
				task_info.getReview_five_day(),
				task_info.getReview_five_day_info(),
				task_info.getReview_six_day(),
				task_info.getReview_six_day_info(),
				task_info.getReview_seven_day(),
				task_info.getReview_seven_day_info(),
				task_info.getReview_eight_day(),
				task_info.getReview_eight_day_info(),
				task_info.getReview_nine_day(),
				task_info.getReview_nine_day_info(),
				task_info.getReview_ten_day(),
				task_info.getReview_ten_day_info(),
				task_info.getReview_charge(), 
				task_info.getFeedback_one_day(),
				task_info.getFeedback_one_day_info(),
				task_info.getFeedback_two_day(),
				task_info.getFeedback_two_day_info(),
				task_info.getFeedback_three_day(),
				task_info.getFeedback_three_day_info(),
				task_info.getFeedback_four_day(),
				task_info.getFeedback_four_day_info(),
				task_info.getFeedback_five_day(),
				task_info.getFeedback_five_day_info(),
				task_info.getFeedback_six_day(),
				task_info.getFeedback_six_day_info(),
				task_info.getFeedback_seven_day(),
				task_info.getFeedback_seven_day_info(),
				task_info.getFeedback_eight_day(),
				task_info.getFeedback_eight_day_info(),
				task_info.getFeedback_nine_day(),
				task_info.getFeedback_nine_day_info(),
				task_info.getFeedback_ten_day(),
				task_info.getFeedback_ten_day_info(),
				task_info.getFeedback_charge(),
				task_info.getFlow_url_one_day(),
				task_info.getFlow_url_two_day(),
				task_info.getFlow_url_three_day(),
				task_info.getFlow_url_four_day(),
				task_info.getFlow_url_five_day(),
				task_info.getFlow_url_six_day(),
				task_info.getFlow_url_seven_day(),
				task_info.getFlow_url_eight_day(),
				task_info.getFlow_url_nine_day(),
				task_info.getFlow_url_ten_day(),
				task_info.getFlow_url_charge(),
				task_info.getFlow_result_one_day(),
				task_info.getFlow_result_two_day(),
				task_info.getFlow_result_three_day(),
				task_info.getFlow_result_four_day(),
				task_info.getFlow_result_five_day(),
				task_info.getFlow_result_six_day(),
				task_info.getFlow_result_seven_day(),
				task_info.getFlow_result_eight_day(),
				task_info.getFlow_result_nine_day(),
				task_info.getFlow_result_ten_day(),
				task_info.getFlow_result_charge(),
				task_info.getFlow_ad_one_day(),
				task_info.getFlow_ad_two_day(),
				task_info.getFlow_ad_three_day(),
				task_info.getFlow_ad_four_day(),
				task_info.getFlow_ad_five_day(),
				task_info.getFlow_ad_six_day(),
				task_info.getFlow_ad_seven_day(),
				task_info.getFlow_ad_eight_day(),
				task_info.getFlow_ad_nine_day(),
				task_info.getFlow_ad_ten_day(),
				task_info.getFlow_ad_charge(),
				task_info.getWish_url_one_day(),
				task_info.getWish_url_two_day(),
				task_info.getWish_url_three_day(),
				task_info.getWish_url_four_day(),
				task_info.getWish_url_five_day(),
				task_info.getWish_url_six_day(),
				task_info.getWish_url_seven_day(),
				task_info.getWish_url_eight_day(),
				task_info.getWish_url_nine_day(),
				task_info.getWish_url_ten_day(),
				task_info.getWish_url_charge(),
				task_info.getWish_result_one_day(),
				task_info.getWish_result_two_day(),
				task_info.getWish_result_three_day(),
				task_info.getWish_result_four_day(),
				task_info.getWish_result_five_day(),
				task_info.getWish_result_six_day(),
				task_info.getWish_result_seven_day(),
				task_info.getWish_result_eight_day(),
				task_info.getWish_result_nine_day(),
				task_info.getWish_result_ten_day(),
				task_info.getWish_result_charge(),
				task_info.getCart_url_one_day(),
				task_info.getCart_url_two_day(),
				task_info.getCart_url_three_day(),
				task_info.getCart_url_four_day(),
				task_info.getCart_url_five_day(),
				task_info.getCart_url_six_day(),
				task_info.getCart_url_seven_day(),
				task_info.getCart_url_eight_day(),
				task_info.getCart_url_nine_day(),
				task_info.getCart_url_ten_day(),
				task_info.getCart_url_charge(),
				task_info.getCart_result_one_day(),
				task_info.getCart_result_two_day(),
				task_info.getCart_result_three_day(),
				task_info.getCart_result_four_day(),
				task_info.getCart_result_five_day(),
				task_info.getCart_result_six_day(),
				task_info.getCart_result_seven_day(),
				task_info.getCart_result_eight_day(),
				task_info.getCart_result_nine_day(),
				task_info.getCart_result_ten_day(),
				task_info.getCart_result_charge(), 
				task_info.getCreatetime(),
				task_info.getFlow_checked(),
				task_info.getFlow_rate(),
				task_info.getHope_checked(),
				task_info.getHope_rate(),
				task_info.getFavorite_checked(),
				task_info.getFavorite_rate(),
				task_info.getPay_remark(),
				task_info.getProcedureNum(),
				task_info.getPayNum(),
				task_info.getOrderState(),
				task_info.getOrder_check(),
				task_info.getQuestion(),
				task_info.getPing_title(),
				task_info.getYasin(),
				task_info.getYsale_id(), task_info.getYpro_price(),
				task_info.getYp_price(), task_info.getYpro_key(),
				task_info.getYpro_url(), task_info.getYpro_title(),
				task_info.getYpro_name(), task_info.getSiteId(),
				task_info.getOrderNo()) > 0;
	}

}
